package com.canis.stockmanager.repository;

import com.canis.stockmanager.domai.VpnBox;
import com.canis.stockmanager.domai.view.VpnBoxView;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface VpnBoxRepository   extends JpaRepository<VpnBox, Long> {
    //@Query("select id,connect_time,login_time,ip,resource_ip,port,mac,uuid,version,resource_port,latest_heartbeat_time,is_update,account,account_name,distributor_name from VpnBox where mac like ?1")
    Page<VpnBox> findByMacContainingAndResourceIpContaining(String mac,String resourceIp,Pageable pageable);

}